<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Admin\Contract;
use App\Admin\Client;
use DB;
use Illuminate\Support\Facades\Schema;
use QrCode;

// use App\Exports\UsersExport;
// use Maatwebsite\Excel\Facades\Excel;

class ContractLetterController extends Controller
{
    public function index(){
        $data = DB::table('a_contract_letter as a')
                  ->leftJoin('a_contract as b', 'a.contract_id', '=', 'b.id')
                  ->select('a.*', 'b.batchNum')
                  ->get();
        return view('admin.contract.letter.index', compact('data'));
    }
}
